

DROP TABLE IF EXISTS jms_dm.dm_sham_send_monitor_sum_dt ;

create external table jms_dm.dm_sham_send_monitor_sum_dt
(
taking_time string comment '揽收时间',
network_code string comment '网点code(责任)',
network_name string comment '网点名称(责任)',
network_type string comment '网点类型1-总部,2-代理区,3-加盟商,4-中心,5-集散点,6-网点',
agent_code string comment '代理区code(责任)',
agent_name string comment '代理区名称(责任)',
total_cnt int comment '总件量',
start_code_stay_ovtime_cnt int comment '始发网点停留超时票件量',
start_code_center_ovtime_cnt int comment '始发网点-始发中心超时票件量',
first_center_ovtime_cnt int comment '始发中心停留超时超时票件量',
first_center_transit_ovtime_cnt int comment '始发中心-中转机构票件量',
transit_center_stay_ovtime_cnt int comment '中转机构停留超时票件量',
transit_center_run_ovtime_cnt int comment '中转环节流转超时票件量',
end_center_cnt int comment '末端中心票件量',
end_center_ovtime_cnt int comment '末端中心流转超时票件量',
end_code_stay_ovtime_cnt int comment '末端网点停留超时票件量'
)
COMMENT '虚假发货监控-汇总表'
PARTITIONED BY (dt STRING COMMENT '分区日期')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_sham_send_monitor_sum_dt'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
);
